﻿CREATE TABLE [dbo].[SupplierContact] (
    [Id_SupplierContact] INT           IDENTITY (1, 1) NOT NULL,
    [Id_Supplier]        INT           NOT NULL,
    [Name]               VARCHAR (100) COLLATE SQL_Latin1_General_CP850_CI_AI NOT NULL,
    [Department]         VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NOT NULL,
    [Phone_Comercial]    VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Phone_Residence]    VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Phone_Cell]         VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Phone_Fax]          VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Email]              VARCHAR (100) COLLATE SQL_Latin1_General_CP850_CI_AI NULL
);

